Microsoft Excel File Data Source

Please enter the following parameters to connect to Microsoft Excel File as data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Directory path: directory where the excel file resides, must be accessible by the CData Virtuality Server
• File name: name of the excel file with the extension
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates